--BACKUP log testDB with no_log

USE eFactory; 
GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE eFactory SET RECOVERY SIMPLE;

GO

-- Shrink the trun cated log file to 1 MB.

DBCC SHRINKFILE (hq_data_log, 5); 
GO

-- Reset the database recovery model.

ALTER DATABASE eFactory SET RECOVERY FULL; 
GO